package com.gsta.cdn.cdr.service;

import com.baomidou.mybatisplus.service.IService;
import com.gsta.cdn.cdr.entity.ServiceTypeRatings;

import java.util.List;
import java.util.Map;

public interface ServiceTypeRatingsService extends IService<ServiceTypeRatings> {
    List<Map<String, Object>> ServiceTypeCount(String date,int page,int pageSize);

    List<Map<String, Object>> ServiceTypeCountByArea(String date,String SP,String Area,int page,int pageSize);
    int ServiceTypeCountByAreaTotal(String date,String SP,String Area);
    List<Map<String, Object>> ServiceTypeCountAvgByArea(String date,String SP,String Area);
    List<Map<String, Object>> ServiceTypeTotalByArea(String date,String SP,String Area);

    List<Map<String, Object>> ServiceTypeCountByPopID(String date,String SP,String PopID,int page,int pageSize);
    int ServiceTypeCountByPopIDTotal(String date,String SP,String PopID);
    List<Map<String, Object>> ServiceTypeCountAvgByPopID(String date,String SP,String PopID);
    List<Map<String, Object>> ServiceTypeTotalByPopID(String date,String SP,String PopID);

    List<Map<String, Object>> ServiceTypeCountByPopName(String date,String PopName,String SP,int page,int pageSize);
    int ServiceTypeCountByPopNameTotal(String date,String PopName,String SP);
    List<Map<String, Object>> ServiceTypeCountAvgByPopName(String date,String PopName,String SP);
    List<Map<String, Object>> ServiceTypeTotalByPopName(String date,String PopName,String SP);
    List<Map<String, Object>> ServiceTypeCountPopNameGet(String date,int page,int pageSize);

    List<Map<String, Object>> ServiceTypeCountBySP(String date,String SP,int page,int pageSize);
    int ServiceTypeCountBySPTotal(String date,String SP);
    List<Map<String, Object>> ServiceTypeCountAvgBySP(String date,String SP,int page,int pageSize);
    List<Map<String, Object>> ServiceTypeTotalBySP(String date,String SP);

    List<Map<String, Object>> ServiceTypeArea(String date);
    List<Map<String, Object>> ServiceTypeAreaSP(String date,String Area);
    List<Map<String, Object>> ServiceTypeAreaPopName(String date,String Area,String SP);

    List<Map<String, Object>> ServiceTypeByAreaAndPopName(String date,String Area,String SP,String PopName,int page,int pageSize);
    List<Map<String, Object>> ServiceTypeAvgByAreaAndPopName(String date,String Area,String SP,String PopName);
    List<Map<String, Object>> ServiceTypeTotalByAreaAndPopName(String date,String Area,String SP,String PopName);

    List<Map<String, Object>> ServiceTypePopIDSP(String date,String PopID);
    int countSum(String date);

    List<Map<String, Object>> ServiceTypePopID(String date);
}
